package com.itheima.mapper;

import com.itheima.pojo.Article;
import com.itheima.pojo.ArticleQueryParam;
import com.itheima.pojo.Category;
import com.itheima.service.ArticleService;
import org.apache.ibatis.annotations.*;
import org.springframework.web.bind.annotation.PostMapping;

import java.util.List;

@Mapper
public interface ArticleMapper {

    @Insert("insert into article (title, content, cover_img, state, category_id, create_user, create_time, update_time)" +
            " values(#{title}, #{content}, #{coverImg}, #{state}, #{categoryId}, #{createUser}, now(), now())")
    void addArticle(Article article);

    List<Article> list(Integer userId, Integer categoryId, String state);

    @Select("select * from article where id = #{id}")
    Article getDetailById(Integer id);

    @Update("update article set title = #{title}, content = #{content}, cover_img = #{coverImg}, state = #{state}, " +
            "category_id = #{categoryId}, update_time = now() where id = #{id}")
    void updateArticle(Article art);

    @Delete("delete from article where id = #{id}")
    void deleteArticle(Integer id);

}
